#!/bin/bash
arr=(ads_aml_customer_risk_profile ads_aml_daily_risk_report ads_aml_regulatory_monthly ads_aml_alert_efficiency)
for i in ${arr[@]};do
sqoop export \
--connect "jdbc:mysql://192.168.88.148:3306/ads_aml" \
--username root \
--password 123456 \
--table $i \
--hcatalog-table $i \
--hcatalog-database ads_aml \
--input-fields-terminated-by '\001' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 1